The directory assigned to the USER_DUMP_DEST parameter should be protected from unauthorized access.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-3851	DO0235-ORACLE10	SV-24874r1_rule	DCPA-1	Medium

Description
The USER_DUMP_DEST parameter is used to indicate the directory where files used for debugging applications will be stored. These files may contain sensitive data or information that could prove useful to potential attackers.

STIG	Date
Oracle 10 Database Instance STIG	2014-01-14

Details

Check Text ( C-29427r1_chk )
From SQL*Plus: select value from v$parameter where name='user_dump_dest'; On UNIX systems: ls -ld [pathname] Substitute [pathname] with the directory path listed from the above SQL command. If permissions are granted for world access, this is a Finding. On Windows Systems (From Windows Explorer): Browse to the directory specified. Select and right-click on the directory, select Properties, select the Security tab. If permissions are granted to everyone, this is a Finding. If any account other than the Oracle process and software owner accounts, Administrators, DBAs, System group or developers authorized to write and debug applications on this database are listed, this is a Finding.

Check Text ( C-29427r1_chk )

From SQL*Plus:

select value from v$parameter where name='user_dump_dest';

On UNIX systems:

ls -ld [pathname]

Substitute [pathname] with the directory path listed from the above SQL command.

If permissions are granted for world access, this is a Finding.

On Windows Systems (From Windows Explorer):

Browse to the directory specified.

Select and right-click on the directory, select Properties, select the Security tab.

If permissions are granted to everyone, this is a Finding.

If any account other than the Oracle process and software owner accounts, Administrators, DBAs, System group or developers authorized to write and debug applications on this database are listed, this is a Finding.

Fix Text (F-26456r1_fix)
Alter host system permissions to the USER_DUMP_DEST directory to the Oracle process and software owner accounts, DBAs, SAs if required, and developers or other users that may specifically require access for debugging or other purposes. Authorize and document user access requirements to the directory outside of the Oracle, DBA and SA account list in the System Security Plan.